---Update Branch_Information Set BR_Code='EN'
delete from AccessRights_Employees where User_Code<>'0001'

--Update Branch_Information set BuyXForY=0--put 1 if they want to Have BUY X FOR Y


delete from syskeys
Update User_Logins Set Br_Code=(Select Br_Code from Branch_Information)


----if user wants to logout after everytransaction---
------------------------------------------------------------------------------------------------------
--Update Branch_Information set LogOutAfterTransaction=1
------------------------------------------------------------------------------------------------------
----if swipe feature is available
------------------------------------------------------------------------------------------------------
--Update Branch_Information set HasSwipeFeature=1
---------------------------------------------------------------------------------------------------------

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Sizes List','Fittings List','Colors List','Multi Products')

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen='Stock In'


Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Magazine Types','Customer Magazines Link','Customer Magazines Delivery')

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Rooms','Services','Services and Rooms Linking','Customer Compliments Letter','Customer Medical History List','Customer Compliments','Customer Recurring Deposits List','Shifts List','Shifts Definition')



delete from BankDetails
DELETE FROM Appointments_Sub_Detail
DELETE FROM Appointments_Detail
DELETE FROM Appointments_Master

delete from CashDrawer_Dtl
delete from CashDrawer_Log
delete from CashDrawer_Mst
delete from Customer_Compliments_Letters

DELETE FROM Customer_MedicalHistory_Link
DELETE FROM CustomerComplimentList
DELETE FROM CustomerMedicalHistoryList

delete from Customers
delete from CustomerType_Product_Qty_PriceList

delete from Customer_Types

delete from EndDay_BalancingDtl
delete from EndDay_BalancingMst
delete from Grn_Dtl
delete from Grn_Mst
delete from HoldSales_Dtl
delete from HoldSales_Mst


DELETE FROM Locations_Master where ShopFloor<>'Y'

DELETE FROM Log_Detail
DELETE FROM Log_MASTER

delete from Login_History

delete from Payment_Details
delete from PettyCash

delete from Product_Qty_PriceList where centralProductCode not in ('9999','0000','1111')
delete from Product_Supplier_BarCodes where centralProductCode not in ('9999','0000','1111')
delete from Product_Master where central_Product_Code not in ('9999','0000','1111')

delete from subcategories where Category_ID2 not in (Select SubcategoryID from Product_master where SubcategoryID is not null and central_Product_Code in ('9999','0000','1111'))
delete from Product_Categories_Level2 where Category_ID2 not in (Select Category_ID2 from Product_master where central_Product_Code in ('9999','0000','1111'))
delete from Product_Categories_Level1 where Category_ID1 not in (Select Category_ID1 from Product_master where central_Product_Code in ('9999','0000','1111'))and category_id1 not in (select category_id1 from subcategories)

delete from Product_StockList

delete from ProductMovement_Dtl
delete from ProductMovement_Mst
delete from Promotions_Detail
delete from Promotions_Master
delete from Purchase_Order_Details
delete from Purchase_Orders
DELETE FROM Purchase_Payment_Details
DELETE FROM Purchase_Inv_Entry_Detail
DELETE FROM Purchase_Inv_Entry_MASTER


DELETE FROM Purchase_Payment_mASTER

DELETE FROM Sales_Payment_Details
DELETE FROM Sales_Payment_MASTER

DELETE FROM Service_Rooms
DELETE FROM Service_Rooms_Linking
DELETE FROM Services_Users_Linking

DELETE FROM Services_MixedServices
DELETE FROM Services_Pricing
DELETE FROM Services_Master

delete from Refund_Detail
delete from Refund_Mst
delete from Repacking_Detail
delete from Repacking_Master

DELETE FROM CustomerMagazines_Delivery
DELETE FROM CustomerMagazines_DeliveryDetail
DELETE FROM CustomerMagazines_DeliveryMaster


DELETE FROM CustomerMagazinesLink_Detail
DELETE FROM CustomerMagazinesLink_Master


delete from Sales_Dtl
delete from Sales_Mst
delete from Stock_Transactions
delete from StockAdjustment_Dtl
delete from StockAdjustmentMaster

delete from Supplier_Details
--delete from TillSettings
DELETE FROM User_ClockIn_ClockOut

DELETE FROM User_Commissions_Dtl_Overall
DELETE FROM User_Commissions_Detail
DELETE FROM User_Salary_Log
DELETE FROM User_Commissions_mASTER
DELETE FROM User_Logins  where Usr_Code<>'0001'


delete FROM [dbo].[Employee_Shifts_Dtl]

delete FROM [dbo].[Services_Users_Linking]

delete FROM [dbo].[Appointments_Sub_Detail]


delete FROM [dbo].[Appointments_master]
delete FROM [dbo].[Appointments_Detail]